Add db migration
Glenn 'devalias' Grant
1 changed files with 21 additions and 0 deletions
+ 21
- 0
db/migrate/20140603104211_rename_digest_email_to_email_digest.rb
@@ -0,0 +1,21 @@ |
||
| 1 |
+class RenameDigestEmailToEmailDigest < ActiveRecord::Migration |
|
| 2 |
+ def up |
|
| 3 |
+ sql = <<-SQL |
|
| 4 |
+ UPDATE #{ActiveRecord::Base.connection.quote_table_name('agents')}
|
|
| 5 |
+ SET #{ActiveRecord::Base.connection.quote_column_name('type')} = "EmailDigestAgent"
|
|
| 6 |
+ WHERE #{ActiveRecord::Base.connection.quote_column_name('type')} = "DigestEmailAgent"
|
|
| 7 |
+ SQL |
|
| 8 |
+ |
|
| 9 |
+ execute sql |
|
| 10 |
+ end |
|
| 11 |
+ |
|
| 12 |
+ def down |
|
| 13 |
+ sql = <<-SQL |
|
| 14 |
+ UPDATE #{ActiveRecord::Base.connection.quote_table_name('agents')}
|
|
| 15 |
+ SET #{ActiveRecord::Base.connection.quote_column_name('type')} = "DigestEmailAgent"
|
|
| 16 |
+ WHERE #{ActiveRecord::Base.connection.quote_column_name('type')} = "EmailDigestAgent"
|
|
| 17 |
+ SQL |
|
| 18 |
+ |
|
| 19 |
+ execute sql |
|
| 20 |
+ end |
|
| 21 |
+end |